Release 10.1A: OpenEdge Data Management:
DataServer for Microsoft SQL Server

RECID function

For backward compatibility, the DataServer supports the RECID function for MSS data source tables that have a unique 4-byte integer column.

When create RECID field is switched on, the Progress-to-MSS migration utility creates an indexed NUMBER column with unique values for each row called PROGRESS_RECID. You can also add this column to tables manually if you are using an existing MS SQL Server database or if you ported an OpenEdge database without the create RECID field switched on.

If the PROGRESS _RECID field does not exist in the table, the DataServer utility automatically designates the index that meets the unique key criteria. For a complete description of the RECID function, see its reference entry in OpenEdge Development: Progress 4GL Reference .

You can make an existing application that includes RECID behave more consistently across data sources by replacing RECID with ROWID. See the "ROWID function" section for more information.